/**
 * This file is part of mycollab-services.
 *
 * mycollab-services is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * mycollab-services is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with mycollab-services.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.mycollab.module.crm.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@SuppressWarnings("ucd")
public class AccountExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public AccountExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andAccountnameIsNull() {
            addCriterion("accountName is null");
            return (Criteria) this;
        }

        public Criteria andAccountnameIsNotNull() {
            addCriterion("accountName is not null");
            return (Criteria) this;
        }

        public Criteria andAccountnameEqualTo(String value) {
            addCriterion("accountName =", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotEqualTo(String value) {
            addCriterion("accountName <>", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameGreaterThan(String value) {
            addCriterion("accountName >", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameGreaterThanOrEqualTo(String value) {
            addCriterion("accountName >=", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLessThan(String value) {
            addCriterion("accountName <", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLessThanOrEqualTo(String value) {
            addCriterion("accountName <=", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameLike(String value) {
            addCriterion("accountName like", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotLike(String value) {
            addCriterion("accountName not like", value, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameIn(List<String> values) {
            addCriterion("accountName in", values, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotIn(List<String> values) {
            addCriterion("accountName not in", values, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameBetween(String value1, String value2) {
            addCriterion("accountName between", value1, value2, "accountname");
            return (Criteria) this;
        }

        public Criteria andAccountnameNotBetween(String value1, String value2) {
            addCriterion("accountName not between", value1, value2, "accountname");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNull() {
            addCriterion("website is null");
            return (Criteria) this;
        }

        public Criteria andWebsiteIsNotNull() {
            addCriterion("website is not null");
            return (Criteria) this;
        }

        public Criteria andWebsiteEqualTo(String value) {
            addCriterion("website =", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotEqualTo(String value) {
            addCriterion("website <>", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThan(String value) {
            addCriterion("website >", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteGreaterThanOrEqualTo(String value) {
            addCriterion("website >=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThan(String value) {
            addCriterion("website <", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLessThanOrEqualTo(String value) {
            addCriterion("website <=", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteLike(String value) {
            addCriterion("website like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotLike(String value) {
            addCriterion("website not like", value, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteIn(List<String> values) {
            addCriterion("website in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotIn(List<String> values) {
            addCriterion("website not in", values, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteBetween(String value1, String value2) {
            addCriterion("website between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andWebsiteNotBetween(String value1, String value2) {
            addCriterion("website not between", value1, value2, "website");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeIsNull() {
            addCriterion("phoneOffice is null");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeIsNotNull() {
            addCriterion("phoneOffice is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeEqualTo(String value) {
            addCriterion("phoneOffice =", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeNotEqualTo(String value) {
            addCriterion("phoneOffice <>", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeGreaterThan(String value) {
            addCriterion("phoneOffice >", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeGreaterThanOrEqualTo(String value) {
            addCriterion("phoneOffice >=", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeLessThan(String value) {
            addCriterion("phoneOffice <", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeLessThanOrEqualTo(String value) {
            addCriterion("phoneOffice <=", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeLike(String value) {
            addCriterion("phoneOffice like", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeNotLike(String value) {
            addCriterion("phoneOffice not like", value, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeIn(List<String> values) {
            addCriterion("phoneOffice in", values, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeNotIn(List<String> values) {
            addCriterion("phoneOffice not in", values, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeBetween(String value1, String value2) {
            addCriterion("phoneOffice between", value1, value2, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andPhoneofficeNotBetween(String value1, String value2) {
            addCriterion("phoneOffice not between", value1, value2, "phoneoffice");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneIsNull() {
            addCriterion("alternatePhone is null");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneIsNotNull() {
            addCriterion("alternatePhone is not null");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneEqualTo(String value) {
            addCriterion("alternatePhone =", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneNotEqualTo(String value) {
            addCriterion("alternatePhone <>", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneGreaterThan(String value) {
            addCriterion("alternatePhone >", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneGreaterThanOrEqualTo(String value) {
            addCriterion("alternatePhone >=", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneLessThan(String value) {
            addCriterion("alternatePhone <", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneLessThanOrEqualTo(String value) {
            addCriterion("alternatePhone <=", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneLike(String value) {
            addCriterion("alternatePhone like", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneNotLike(String value) {
            addCriterion("alternatePhone not like", value, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneIn(List<String> values) {
            addCriterion("alternatePhone in", values, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneNotIn(List<String> values) {
            addCriterion("alternatePhone not in", values, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneBetween(String value1, String value2) {
            addCriterion("alternatePhone between", value1, value2, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAlternatephoneNotBetween(String value1, String value2) {
            addCriterion("alternatePhone not between", value1, value2, "alternatephone");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueIsNull() {
            addCriterion("annualRevenue is null");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueIsNotNull() {
            addCriterion("annualRevenue is not null");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueEqualTo(String value) {
            addCriterion("annualRevenue =", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueNotEqualTo(String value) {
            addCriterion("annualRevenue <>", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueGreaterThan(String value) {
            addCriterion("annualRevenue >", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueGreaterThanOrEqualTo(String value) {
            addCriterion("annualRevenue >=", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueLessThan(String value) {
            addCriterion("annualRevenue <", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueLessThanOrEqualTo(String value) {
            addCriterion("annualRevenue <=", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueLike(String value) {
            addCriterion("annualRevenue like", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueNotLike(String value) {
            addCriterion("annualRevenue not like", value, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueIn(List<String> values) {
            addCriterion("annualRevenue in", values, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueNotIn(List<String> values) {
            addCriterion("annualRevenue not in", values, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueBetween(String value1, String value2) {
            addCriterion("annualRevenue between", value1, value2, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andAnnualrevenueNotBetween(String value1, String value2) {
            addCriterion("annualRevenue not between", value1, value2, "annualrevenue");
            return (Criteria) this;
        }

        public Criteria andBillingaddressIsNull() {
            addCriterion("billingAddress is null");
            return (Criteria) this;
        }

        public Criteria andBillingaddressIsNotNull() {
            addCriterion("billingAddress is not null");
            return (Criteria) this;
        }

        public Criteria andBillingaddressEqualTo(String value) {
            addCriterion("billingAddress =", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotEqualTo(String value) {
            addCriterion("billingAddress <>", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressGreaterThan(String value) {
            addCriterion("billingAddress >", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressGreaterThanOrEqualTo(String value) {
            addCriterion("billingAddress >=", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressLessThan(String value) {
            addCriterion("billingAddress <", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressLessThanOrEqualTo(String value) {
            addCriterion("billingAddress <=", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressLike(String value) {
            addCriterion("billingAddress like", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotLike(String value) {
            addCriterion("billingAddress not like", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressIn(List<String> values) {
            addCriterion("billingAddress in", values, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotIn(List<String> values) {
            addCriterion("billingAddress not in", values, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressBetween(String value1, String value2) {
            addCriterion("billingAddress between", value1, value2, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotBetween(String value1, String value2) {
            addCriterion("billingAddress not between", value1, value2, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andPostalcodeIsNull() {
            addCriterion("postalCode is null");
            return (Criteria) this;
        }

        public Criteria andPostalcodeIsNotNull() {
            addCriterion("postalCode is not null");
            return (Criteria) this;
        }

        public Criteria andPostalcodeEqualTo(String value) {
            addCriterion("postalCode =", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeNotEqualTo(String value) {
            addCriterion("postalCode <>", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeGreaterThan(String value) {
            addCriterion("postalCode >", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("postalCode >=", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeLessThan(String value) {
            addCriterion("postalCode <", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeLessThanOrEqualTo(String value) {
            addCriterion("postalCode <=", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeLike(String value) {
            addCriterion("postalCode like", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeNotLike(String value) {
            addCriterion("postalCode not like", value, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeIn(List<String> values) {
            addCriterion("postalCode in", values, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeNotIn(List<String> values) {
            addCriterion("postalCode not in", values, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeBetween(String value1, String value2) {
            addCriterion("postalCode between", value1, value2, "postalcode");
            return (Criteria) this;
        }

        public Criteria andPostalcodeNotBetween(String value1, String value2) {
            addCriterion("postalCode not between", value1, value2, "postalcode");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(String value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(String value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(String value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(String value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLike(String value) {
            addCriterion("state like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotLike(String value) {
            addCriterion("state not like", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<String> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<String> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(String value1, String value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andOwnershipIsNull() {
            addCriterion("ownership is null");
            return (Criteria) this;
        }

        public Criteria andOwnershipIsNotNull() {
            addCriterion("ownership is not null");
            return (Criteria) this;
        }

        public Criteria andOwnershipEqualTo(String value) {
            addCriterion("ownership =", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipNotEqualTo(String value) {
            addCriterion("ownership <>", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipGreaterThan(String value) {
            addCriterion("ownership >", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipGreaterThanOrEqualTo(String value) {
            addCriterion("ownership >=", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipLessThan(String value) {
            addCriterion("ownership <", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipLessThanOrEqualTo(String value) {
            addCriterion("ownership <=", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipLike(String value) {
            addCriterion("ownership like", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipNotLike(String value) {
            addCriterion("ownership not like", value, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipIn(List<String> values) {
            addCriterion("ownership in", values, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipNotIn(List<String> values) {
            addCriterion("ownership not in", values, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipBetween(String value1, String value2) {
            addCriterion("ownership between", value1, value2, "ownership");
            return (Criteria) this;
        }

        public Criteria andOwnershipNotBetween(String value1, String value2) {
            addCriterion("ownership not between", value1, value2, "ownership");
            return (Criteria) this;
        }

        public Criteria andShippingaddressIsNull() {
            addCriterion("shippingAddress is null");
            return (Criteria) this;
        }

        public Criteria andShippingaddressIsNotNull() {
            addCriterion("shippingAddress is not null");
            return (Criteria) this;
        }

        public Criteria andShippingaddressEqualTo(String value) {
            addCriterion("shippingAddress =", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotEqualTo(String value) {
            addCriterion("shippingAddress <>", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressGreaterThan(String value) {
            addCriterion("shippingAddress >", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressGreaterThanOrEqualTo(String value) {
            addCriterion("shippingAddress >=", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressLessThan(String value) {
            addCriterion("shippingAddress <", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressLessThanOrEqualTo(String value) {
            addCriterion("shippingAddress <=", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressLike(String value) {
            addCriterion("shippingAddress like", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotLike(String value) {
            addCriterion("shippingAddress not like", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressIn(List<String> values) {
            addCriterion("shippingAddress in", values, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotIn(List<String> values) {
            addCriterion("shippingAddress not in", values, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressBetween(String value1, String value2) {
            addCriterion("shippingAddress between", value1, value2, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotBetween(String value1, String value2) {
            addCriterion("shippingAddress not between", value1, value2, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingcityIsNull() {
            addCriterion("shippingCity is null");
            return (Criteria) this;
        }

        public Criteria andShippingcityIsNotNull() {
            addCriterion("shippingCity is not null");
            return (Criteria) this;
        }

        public Criteria andShippingcityEqualTo(String value) {
            addCriterion("shippingCity =", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotEqualTo(String value) {
            addCriterion("shippingCity <>", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityGreaterThan(String value) {
            addCriterion("shippingCity >", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityGreaterThanOrEqualTo(String value) {
            addCriterion("shippingCity >=", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityLessThan(String value) {
            addCriterion("shippingCity <", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityLessThanOrEqualTo(String value) {
            addCriterion("shippingCity <=", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityLike(String value) {
            addCriterion("shippingCity like", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotLike(String value) {
            addCriterion("shippingCity not like", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityIn(List<String> values) {
            addCriterion("shippingCity in", values, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotIn(List<String> values) {
            addCriterion("shippingCity not in", values, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityBetween(String value1, String value2) {
            addCriterion("shippingCity between", value1, value2, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotBetween(String value1, String value2) {
            addCriterion("shippingCity not between", value1, value2, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeIsNull() {
            addCriterion("shippingPostalCode is null");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeIsNotNull() {
            addCriterion("shippingPostalCode is not null");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeEqualTo(String value) {
            addCriterion("shippingPostalCode =", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotEqualTo(String value) {
            addCriterion("shippingPostalCode <>", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeGreaterThan(String value) {
            addCriterion("shippingPostalCode >", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("shippingPostalCode >=", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeLessThan(String value) {
            addCriterion("shippingPostalCode <", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeLessThanOrEqualTo(String value) {
            addCriterion("shippingPostalCode <=", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeLike(String value) {
            addCriterion("shippingPostalCode like", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotLike(String value) {
            addCriterion("shippingPostalCode not like", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeIn(List<String> values) {
            addCriterion("shippingPostalCode in", values, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotIn(List<String> values) {
            addCriterion("shippingPostalCode not in", values, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeBetween(String value1, String value2) {
            addCriterion("shippingPostalCode between", value1, value2, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotBetween(String value1, String value2) {
            addCriterion("shippingPostalCode not between", value1, value2, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingstateIsNull() {
            addCriterion("shippingState is null");
            return (Criteria) this;
        }

        public Criteria andShippingstateIsNotNull() {
            addCriterion("shippingState is not null");
            return (Criteria) this;
        }

        public Criteria andShippingstateEqualTo(String value) {
            addCriterion("shippingState =", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotEqualTo(String value) {
            addCriterion("shippingState <>", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateGreaterThan(String value) {
            addCriterion("shippingState >", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateGreaterThanOrEqualTo(String value) {
            addCriterion("shippingState >=", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateLessThan(String value) {
            addCriterion("shippingState <", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateLessThanOrEqualTo(String value) {
            addCriterion("shippingState <=", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateLike(String value) {
            addCriterion("shippingState like", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotLike(String value) {
            addCriterion("shippingState not like", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateIn(List<String> values) {
            addCriterion("shippingState in", values, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotIn(List<String> values) {
            addCriterion("shippingState not in", values, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateBetween(String value1, String value2) {
            addCriterion("shippingState between", value1, value2, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotBetween(String value1, String value2) {
            addCriterion("shippingState not between", value1, value2, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andNumemployeesIsNull() {
            addCriterion("numemployees is null");
            return (Criteria) this;
        }

        public Criteria andNumemployeesIsNotNull() {
            addCriterion("numemployees is not null");
            return (Criteria) this;
        }

        public Criteria andNumemployeesEqualTo(Integer value) {
            addCriterion("numemployees =", value, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesNotEqualTo(Integer value) {
            addCriterion("numemployees <>", value, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesGreaterThan(Integer value) {
            addCriterion("numemployees >", value, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesGreaterThanOrEqualTo(Integer value) {
            addCriterion("numemployees >=", value, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesLessThan(Integer value) {
            addCriterion("numemployees <", value, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesLessThanOrEqualTo(Integer value) {
            addCriterion("numemployees <=", value, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesIn(List<Integer> values) {
            addCriterion("numemployees in", values, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesNotIn(List<Integer> values) {
            addCriterion("numemployees not in", values, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesBetween(Integer value1, Integer value2) {
            addCriterion("numemployees between", value1, value2, "numemployees");
            return (Criteria) this;
        }

        public Criteria andNumemployeesNotBetween(Integer value1, Integer value2) {
            addCriterion("numemployees not between", value1, value2, "numemployees");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNull() {
            addCriterion("createdTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNotNull() {
            addCriterion("createdTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeEqualTo(Date value) {
            addCriterion("createdTime =", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotEqualTo(Date value) {
            addCriterion("createdTime <>", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThan(Date value) {
            addCriterion("createdTime >", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createdTime >=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThan(Date value) {
            addCriterion("createdTime <", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("createdTime <=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIn(List<Date> values) {
            addCriterion("createdTime in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotIn(List<Date> values) {
            addCriterion("createdTime not in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeBetween(Date value1, Date value2) {
            addCriterion("createdTime between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("createdTime not between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNull() {
            addCriterion("createdUser is null");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNotNull() {
            addCriterion("createdUser is not null");
            return (Criteria) this;
        }

        public Criteria andCreateduserEqualTo(String value) {
            addCriterion("createdUser =", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotEqualTo(String value) {
            addCriterion("createdUser <>", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThan(String value) {
            addCriterion("createdUser >", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThanOrEqualTo(String value) {
            addCriterion("createdUser >=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThan(String value) {
            addCriterion("createdUser <", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThanOrEqualTo(String value) {
            addCriterion("createdUser <=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLike(String value) {
            addCriterion("createdUser like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotLike(String value) {
            addCriterion("createdUser not like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserIn(List<String> values) {
            addCriterion("createdUser in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotIn(List<String> values) {
            addCriterion("createdUser not in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserBetween(String value1, String value2) {
            addCriterion("createdUser between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotBetween(String value1, String value2) {
            addCriterion("createdUser not between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNull() {
            addCriterion("sAccountId is null");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNotNull() {
            addCriterion("sAccountId is not null");
            return (Criteria) this;
        }

        public Criteria andSaccountidEqualTo(Integer value) {
            addCriterion("sAccountId =", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotEqualTo(Integer value) {
            addCriterion("sAccountId <>", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThan(Integer value) {
            addCriterion("sAccountId >", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThanOrEqualTo(Integer value) {
            addCriterion("sAccountId >=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThan(Integer value) {
            addCriterion("sAccountId <", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThanOrEqualTo(Integer value) {
            addCriterion("sAccountId <=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidIn(List<Integer> values) {
            addCriterion("sAccountId in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotIn(List<Integer> values) {
            addCriterion("sAccountId not in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId not between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andAssignuserIsNull() {
            addCriterion("assignUser is null");
            return (Criteria) this;
        }

        public Criteria andAssignuserIsNotNull() {
            addCriterion("assignUser is not null");
            return (Criteria) this;
        }

        public Criteria andAssignuserEqualTo(String value) {
            addCriterion("assignUser =", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotEqualTo(String value) {
            addCriterion("assignUser <>", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserGreaterThan(String value) {
            addCriterion("assignUser >", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserGreaterThanOrEqualTo(String value) {
            addCriterion("assignUser >=", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLessThan(String value) {
            addCriterion("assignUser <", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLessThanOrEqualTo(String value) {
            addCriterion("assignUser <=", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLike(String value) {
            addCriterion("assignUser like", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotLike(String value) {
            addCriterion("assignUser not like", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserIn(List<String> values) {
            addCriterion("assignUser in", values, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotIn(List<String> values) {
            addCriterion("assignUser not in", values, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserBetween(String value1, String value2) {
            addCriterion("assignUser between", value1, value2, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotBetween(String value1, String value2) {
            addCriterion("assignUser not between", value1, value2, "assignuser");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(String value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(String value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(String value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(String value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(String value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(String value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLike(String value) {
            addCriterion("type like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotLike(String value) {
            addCriterion("type not like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<String> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<String> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(String value1, String value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(String value1, String value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNull() {
            addCriterion("industry is null");
            return (Criteria) this;
        }

        public Criteria andIndustryIsNotNull() {
            addCriterion("industry is not null");
            return (Criteria) this;
        }

        public Criteria andIndustryEqualTo(String value) {
            addCriterion("industry =", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotEqualTo(String value) {
            addCriterion("industry <>", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThan(String value) {
            addCriterion("industry >", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryGreaterThanOrEqualTo(String value) {
            addCriterion("industry >=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThan(String value) {
            addCriterion("industry <", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLessThanOrEqualTo(String value) {
            addCriterion("industry <=", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryLike(String value) {
            addCriterion("industry like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotLike(String value) {
            addCriterion("industry not like", value, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryIn(List<String> values) {
            addCriterion("industry in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotIn(List<String> values) {
            addCriterion("industry not in", values, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryBetween(String value1, String value2) {
            addCriterion("industry between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andIndustryNotBetween(String value1, String value2) {
            addCriterion("industry not between", value1, value2, "industry");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNull() {
            addCriterion("lastUpdatedTime is null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNotNull() {
            addCriterion("lastUpdatedTime is not null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeEqualTo(Date value) {
            addCriterion("lastUpdatedTime =", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotEqualTo(Date value) {
            addCriterion("lastUpdatedTime <>", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThan(Date value) {
            addCriterion("lastUpdatedTime >", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime >=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThan(Date value) {
            addCriterion("lastUpdatedTime <", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime <=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIn(List<Date> values) {
            addCriterion("lastUpdatedTime in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotIn(List<Date> values) {
            addCriterion("lastUpdatedTime not in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime not between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andBillingcountryIsNull() {
            addCriterion("billingCountry is null");
            return (Criteria) this;
        }

        public Criteria andBillingcountryIsNotNull() {
            addCriterion("billingCountry is not null");
            return (Criteria) this;
        }

        public Criteria andBillingcountryEqualTo(String value) {
            addCriterion("billingCountry =", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotEqualTo(String value) {
            addCriterion("billingCountry <>", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryGreaterThan(String value) {
            addCriterion("billingCountry >", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryGreaterThanOrEqualTo(String value) {
            addCriterion("billingCountry >=", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryLessThan(String value) {
            addCriterion("billingCountry <", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryLessThanOrEqualTo(String value) {
            addCriterion("billingCountry <=", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryLike(String value) {
            addCriterion("billingCountry like", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotLike(String value) {
            addCriterion("billingCountry not like", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryIn(List<String> values) {
            addCriterion("billingCountry in", values, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotIn(List<String> values) {
            addCriterion("billingCountry not in", values, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryBetween(String value1, String value2) {
            addCriterion("billingCountry between", value1, value2, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotBetween(String value1, String value2) {
            addCriterion("billingCountry not between", value1, value2, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryIsNull() {
            addCriterion("shippingCountry is null");
            return (Criteria) this;
        }

        public Criteria andShippingcountryIsNotNull() {
            addCriterion("shippingCountry is not null");
            return (Criteria) this;
        }

        public Criteria andShippingcountryEqualTo(String value) {
            addCriterion("shippingCountry =", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotEqualTo(String value) {
            addCriterion("shippingCountry <>", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryGreaterThan(String value) {
            addCriterion("shippingCountry >", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryGreaterThanOrEqualTo(String value) {
            addCriterion("shippingCountry >=", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryLessThan(String value) {
            addCriterion("shippingCountry <", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryLessThanOrEqualTo(String value) {
            addCriterion("shippingCountry <=", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryLike(String value) {
            addCriterion("shippingCountry like", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotLike(String value) {
            addCriterion("shippingCountry not like", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryIn(List<String> values) {
            addCriterion("shippingCountry in", values, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotIn(List<String> values) {
            addCriterion("shippingCountry not in", values, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryBetween(String value1, String value2) {
            addCriterion("shippingCountry between", value1, value2, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotBetween(String value1, String value2) {
            addCriterion("shippingCountry not between", value1, value2, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andAvataridIsNull() {
            addCriterion("avatarId is null");
            return (Criteria) this;
        }

        public Criteria andAvataridIsNotNull() {
            addCriterion("avatarId is not null");
            return (Criteria) this;
        }

        public Criteria andAvataridEqualTo(String value) {
            addCriterion("avatarId =", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotEqualTo(String value) {
            addCriterion("avatarId <>", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridGreaterThan(String value) {
            addCriterion("avatarId >", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridGreaterThanOrEqualTo(String value) {
            addCriterion("avatarId >=", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridLessThan(String value) {
            addCriterion("avatarId <", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridLessThanOrEqualTo(String value) {
            addCriterion("avatarId <=", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridLike(String value) {
            addCriterion("avatarId like", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotLike(String value) {
            addCriterion("avatarId not like", value, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridIn(List<String> values) {
            addCriterion("avatarId in", values, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotIn(List<String> values) {
            addCriterion("avatarId not in", values, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridBetween(String value1, String value2) {
            addCriterion("avatarId between", value1, value2, "avatarid");
            return (Criteria) this;
        }

        public Criteria andAvataridNotBetween(String value1, String value2) {
            addCriterion("avatarId not between", value1, value2, "avatarid");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_account
     *
     * @mbg.generated do_not_delete_during_merge Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_account
     *
     * @mbg.generated Sun Dec 25 21:29:47 ICT 2016
     */
    @SuppressWarnings("ucd")
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}